include("../dbinfo_inc.php"); $id=$_GET['id']; $urlsource=$_GET['url']; $table_people=$table_people; function find_name($id_person) { include("../dbinfo_inc.php"); mysql_connect($mysqlhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query_person="SELECT * FROM $table_people WHERE id_person='$id_person'"; $result_person=mysql_query($query_person); mysql_close (); if ($result_person) { $num_person=mysql_numrows($result_person);} else { $num_person=0;} $i_person=0; while ($i_person < $num_person) { $name_first=mysql_result($result_person,$i_person,"name_first"); $name_last=mysql_result($result_person,$i_person,"name_last"); $name_preferred=mysql_result($result_person,$i_person,"name_preferred"); ++$i_person; } if ($name_preferred) {$name_to_use = $name_preferred;} else {$name_to_use = $name_first;} return $name_to_use. " " . $name_last; } mysql_connect($mysqlhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); if ($new_ud == "new") { $num_people_ud="1"; } else { $query_people_ud="SELECT * FROM $table_people WHERE id_person=$id_person"; $result_people_ud=mysql_query($query_people_ud); $num_people_ud=mysql_numrows($result_people_ud); } $i_people_ud=0; while ($i_people_ud < $num_people_ud) { if ($new_ud == "ud") { $id_person=mysql_result($result_people_ud,$_people_ud,"id_person"); $date=mysql_result($result_people_ud,$_people_ud,"date"); $date_ud=mysql_result($result_people_ud,$_people_ud,"date_ud"); $time=mysql_result($result_people_ud,$_people_ud,"time"); $time_ud=mysql_result($result_people_ud,$_people_ud,"time_ud"); $name_first=mysql_result($result_people_ud,$i_people_ud,"name_first"); $name_preferred=mysql_result($result_people_ud,$i_people_ud,"name_preferred"); $name_middle=mysql_result($result_people_ud,$i_people_ud,"name_middle"); $name_last=mysql_result($result_people_ud,$i_people_ud,"name_last"); $date_start_vrd=mysql_result($result_people_ud,$i_people_ud,"date_start_vrd"); $date_end_vrd=mysql_result($result_people_ud,$i_people_ud,"date_end_vrd"); $location=mysql_result($result_people_ud,$i_people_ud,"location"); $phone_1=mysql_result($result_people_ud,$i_people_ud,"phone_1"); $phone_1_type=mysql_result($result_people_ud,$i_people_ud,"phone_1_type"); $phone_2=mysql_result($result_people_ud,$i_people_ud,"phone_2"); $phone_2_type=mysql_result($result_people_ud,$i_people_ud,"phone_2_type"); $email_1=mysql_result($result_people_ud,$i_people_ud,"email_1"); $email_2=mysql_result($result_people_ud,$i_people_ud,"email_2"); $comment=mysql_result($result_people_ud,$i_people_ud,"comment"); } mysql_close(); ?>